<html>
  <head>
    <meta charset="utf8" />
    <title>Informations sur les clubs</title>
	<link rel="stylesheet" href="style.css" />
  </head>
  <body>
<?php include("connexion-db.php");
include("retour-index.php"); ?>
    <table>
	<tr>
	<th>N°</th>
	<th>Nom</th>
	<th>Date de création</th>
	</tr>
      <?php
	$query = 'select * from CLUB';
	$res = $db->query($query);
	 while($data = $res->fetch()){
	 ?>
      <tr>
	<td><?php echo $data['ID_CLUB']; ?></td>
	<td><a href="bureau.php?id-club=<?php echo $data['ID_CLUB']; ?>"><?php echo $data['NOM_CLUB']; ?></a></td>
	<td><?php echo $data['DATE_DE_CREATION']; ?></td>
      </tr>
      <?php } ?>
    </table>
       <?php
	$res->closeCursor();
       ?>
  </body>
</html>
